XBRL and the Multidimensional Data Model

نویسندگان

  • Ignacio Santos
  • Elena Castro
چکیده

Nowadays, there is an important development in XML and Data Warehouse (DW) applications. Moreover, companies and financial institutions need more accounting information. In addition, this information must be reliable and on time. XBRL (eXtensible Business Reporting Language) is a global de facto standard, based on XML. XBRL consists of a set of taxonomies, which define different accounting regulations of a specific report. XBRL reports are created from various sources and are validated at source. XBRL represents business information, and it is multidimensional, and therefore the logical destination is a DW. This paper analyzes the data model of XBRL and its semantics, and how to map this data model to the Multidimensional Data Model (MDM), and in turn to the Logical Model, either ROLAP (Relational OLAP), MOLAP (Multidimensional OLAP), or HOLAP (Hybrid OLAP), so they can be analyzed by business users. Figure 1.UML design of XBRL Schemas and linkbases (DTS). XBRL REPORTING LANGUAGE XBRL is a XML-based standard for financial reporting. Charles Hoffman, in April 1998, proposed to automate the exchange of financial information, and he developed the first version. A financial report is based on accounting rules such as International Financial Reporting Standard (IFRS), Basel II, Basel III, and so on. These rules change with time, and it can have different versions, depending on the country. Then, we have version problems. These standards may be international, national, local, by company or financial institutions. This set of rules can be inherited or overwritten. A report consists of an XBRL instance, which is the report itself, and this report has a set of XML Schemas or XBRL Schemas, and, they make up Discoverable Taxonomy Set (DTS). Each XBRL Schema may or may not have up to eight roles, called linkbases (Figure 1). XBRL Dimensional Taxonomies (XDT) consists of dimensions, domains and hypercubes. Figure 2 shows the chart with this specification. We propose to develop a process of transformation of XBRL metadata, to metadata for a multidimensional database (MDM) figure 3. Figure 2.Design the XDT model with UML EXAMPLE GUIDE Our example is based on the 6610 report (Public Sector Consolidated Balance report). Spanish banks send this report to the Supervisor, the Bank of Spain. In figure 4, is shown with the help of Fujitsu’s Xwand tool, the dimensional view of the 6610 report. In figures 5, 6, and 7, we show a graphic representation of the multidimensional relation, a graphic dimensional, and the Multidimensional Data Model. Figure 6.Dimensional graphic of the example 6610 report (Public Sector Consolidated ). Figure 7.Multidimensional Data Model of the 6610 report. Figure 5.Graphic representation of the multidimensional relations of the 6610 report (IS1. Public Sector Consolidated Balance). Figure 4.View of Dimensional table with Xwand of Fujitsu. We have demonstrated that the XBRL reports are dimensional and these can be transformed and automated in an MDM. We want to build an abstract data model, and analyze it, semantically. Ongoing work with the creation the necessary infrastructure of the automation process and its development. And, finally, we want to analyze your performance in each of the stages, and in its entirety. CONCLUSION Figure 3.Global transformation of the XBRL metamodel

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Using XBRL and Quantrix Modeler to Analyze Financial Statements – Part

XBRL (eXtensible Business Reporting Language) is a language based on XML for the electronic communication of business and financial data. This paper is intended to: (1) give a brief presentation of the XBRL language and its applicability to financial analysis; (2) define the requirements of a software application supporting financial analysis and planning capable of processing financial data in...

متن کامل

Business Intelligence in Environmental Reporting Powered by XBRL

The paper discusses several critical points of the whole concept of Business Intelligence (BI) approach to environmental reporting powered by XBRL. First, and most important, is the usage of structured data delivered via XBRL. The main profit on usage of XBRL is the optimization of the Extract, Transform and Load (ETL) process and its combination commonly used best practices on data warehouse m...

متن کامل

XBRL-Trail --- A model for introducing digital forensic readiness to XBRL

Business is reliant on Information Technology to process and share financial data. Proprietary formats often hinder the sharing of financial data as stakeholders can not uniformly read or access the data. As a result, XBRL (The eXtensible Business Reporting Language) was developed to address the information sharing issue, and is rapidly becoming the standard format for financial data. XBRL does...

متن کامل

Accepting the XBRL Challenge with Linked Data for Financial Data Integration

Analysts spend a disproportionate amount of time with financial data curation before they are able to compare company performances in an analysis. The Extensible Business Reporting Language (XBRL) for annotating financial facts is suited for automatic processing to increase information quality in financial analytics. Still, XBRL does not solve the problem of data integration as required for a h...

متن کامل

Research on XBRL Domain Ontology Construction

XBRL (eXtensible Business Reporting Language) as an application of XML (eXtensible Markup Language) technology in the field of business reporting, uses information technology to add tags for the financial reporting metadata, to achieve unstructured data processing effectively. At first, this paper analyzes the XBRL technology framework, finds out the concepts and relationships between them, and...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2011